
import pepe.p_sql.pgtools as pgt 
import pepe.p_sql.pg as pg

'''
pgt.dropTable('tb00')
pgt.loadData(fMask='tb01.dat', cDelimiter='\t')

q = """   COPY 
                (
                select t1.*, t2.* from %s as t1
                full join %s as t2 on t1.c001 = t2.c001
                order by t1.c001
                )
                TO '%s#jkpg.txt' with DELIMITER '^' NULL ''
                """ 
                #% (files[0][:-4], files[1][:-4], posb.wai())
#print q
#pg.Pg(q)
'''


